SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_GetJYZN]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	/* SET NOCOUNT ON */
	SELECT TOP(5) JOL_Bulletin_No, JOL_Bulletin_Title,JOL_Bulletin_AddTime FROM JOL_Bulletin WHERE JOL_Bulletin_SubType = '就业指南' ORDER BY JOL_Bulletin_IsSetTop DESC, JOL_Bulletin_AddTime DESC,JOL_Bulletin_UpdateTime DESC
	RETURN

GO
